How to: Specify query criteria.
Solution:
Select the Data Source and the Tables to be used in the query, then type the criteria sought in the Criteria Pane.
NOTE: Unless specified, the Query includes all records from the source database in the result set displayed in the data pane. Specifying criteria ensures only matches in the source database will be retrieved.
1) Display the 'Select Data Source' dialog box if it is not already displayed on the screen.
a) Select the 'Data' menu and select 'Get External Data...'.
b) Select from the list of 'Available Data Sources'.
2) Click 'Use'. (The Select Database dialog box appears.)
3) Select the database to be used.
4) Click 'OK'. (The Add Tables dialog box appears.)
5) Select the table(s) to be used from the 'Table' list box:
a) Select the table by highlighting it.
b) Click 'Add'.
c) Repeat steps 5)a) and 5)b) as necessary for multiple tables.
d) Click 'Close' when done.
6) Specify criteria from the Table Pane to be used in the Criteria Pane.
NOTE: Double-click the fields in the Table Pane to copy them to the DataPane.
